Grids

Limit records records per page
Checks this option if you want to limit the number of records showed on each page in table grid globally. Otherwise, all records will be displayed in one single page. The number representing the number of records (e.g. 1000) showed per page in table grid.

Note: To adjust the settings for particular table, see Table Viewer.

Limit foreign key editor records records
Checks this option if you want to limit the number of records showed on each page in foreign key data selection globally. Otherwise, all records will be displayed in one single page. The number representing the number of records (e.g. 100) showed per page in Foreign Key Data Selection.

Shading of Table Grid
Defines the background layout of the data grid.

Default Row Height
Defines the height of the row (e.g. 17) used in editor.

Note: To adjust the settings for particular table, see Formatting Table Grid.

Default column width
Defines the width of the column (e.g. 100) used in editor.

Note: To adjust the settings for particular table, see Formatting Table Grid.

Show primary key warning
Checks this option if you require notification while opening the table with no primary key being set.

Default show text
If this option is on, data which set as TEXT field type is visible in table grid. Otherwise, [TEXT] will shown

Default show image
If this option is on, data which set as BLOB field type is visible in table grid. Otherwise, [BLOB] will shown

Trigger editing by double-click
With this option selected, double-clicking on a cell in table will start cell editing. While single-clicking, the row is highlighted.

Show left border for row selection
Border will be shown on the left of the grid. Clicking on the border will highlight the whole row.

Auto commit (Available only for Oracle, SQLite and SQL Server)
Checks this option if you require auto commit of changing records in table grid. Otherwise, you allow choosing Commit or Rollback to commit or rollback the changes. See Table Viewer.